Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 36

In Excel you can zoom a worksheet

a) With the mouse pointer in Print Preview

b) With the zoom button on the Print Preview toolbar

c) With the Zoom command on the view menu

d) All of the above

Question : 37

While Finding and Replacing some data in Excel, which of the following statement is valid?

a) You can Find and Replace within the sheet or workbook

b) Excel does not have option to match case for find

c) Excel cannot replace

d) All of above

e) None of these

Question : 38

Which of the following displays the contents of the active cell?

a) Active cell

b) Formula bar

c) Menu bar

d) Name box

e) None of these

Question : 39

Which of the following special function keys allow the content in cell

a) esc

b) shift

c) return

d) Tab

e) None of these

Question : 40

How can you remove borders applied In cells?

a) Choose None on Border , tab of Format cells

b) Open the list on Border tool in Formatting toolbar then choose first tool (no border)

c) Both of above

d) All of above

e) None of these